Sample Format for Loading Activity and Resource Assignment Data
The table below provides a sample format for loading activities and resource assignments.
WBS | WP | OBS | Baseline Start Date | Baseline Finish Date | Progress Technique | Resource | Hours | Direct |
---|---|---|---|---|---|---|---|---|
1.1 | 1.1.1 | MGT | 8/15/2016 | 8/15/2018 | % Complete | DRAFT | 456 | 0 |
1.1 | 1.1.1 | MGT | 8/15/2016 | 8/15/2018 | % Complete | MANAGER | 320 | 0 |
1.1 | 1.1.1 | MGT | 8/15/2016 | 8/15/2018 | % Complete | SENG | 124 | 0 |
1.1 | 1.1.1 | MGT | 8/15/2016 | 8/15/2018 | % Complete | TECH | 459 | 0 |
1.2 | 1.2.1 | ENG | 8/20/2016 | 8/20/2018 | Milestones | MANAGER | 251 | 0 |
1.2 | 1.2.1 | ENG | 8/20/2016 | 8/20/2018 | Milestones | TECH | 321 | 0 |
1.2 | 1.2.1 | ENG | 8/20/2016 | 8/20/2018 | Milestones | DRAFT | 546 | 0 |
The import file must contain a new row for each resource assignment in a work package. Rows 2-5 of the sample will create Control Account 1.1 and Work Package 1.1.1 with four resources assigned to them and the required hours listed in the Hours column. All results used by the resource calculations are available as columns, which can be loaded from the import file.